//
//  DataBaseHandle.h
//  UI18_DataBase
//
//  Created by dllo on 15/11/18.
//  Copyright (c) 2015年 YXY. All rights reserved.
//

#import <Foundation/Foundation.h>

@interface DataBaseHandle : NSObject
@property (nonatomic, retain) NSDictionary *title;
@property (nonatomic, retain) NSMutableArray *array;

@property (nonatomic, strong) NSMutableArray *downloadingTitle;

@property (nonatomic, strong) NSMutableArray *downloadingPicture;

@property (nonatomic, strong) NSMutableArray *downloadAlreadyTitle;

@property (nonatomic, strong) NSMutableArray *downloadAlreadyPicture;

@property (nonatomic, strong) NSMutableArray *downloadAlreadyAddress;

+ (instancetype)shareDataBase;

- (void)openDataBase;

- (void)closedDataBase;

- (void)createTable;

- (void)insertDatabase:(NSString *)title withids:(NSString *)ids withType:(NSString *)type withImageUrl:(NSString *)imageUrl;
- (NSMutableArray *)selectDataBase;
//- (NSArray *)selectValues;
- (void)updateDataBase:(NSString *)title;
- (void)deleteDataBase:(NSString *)title;


- (void)selectdownloading;
- (void)insertDownloadingDatabase:(NSString *)title withPicture:(NSString *)picture withDownloadUrl:(NSString *)url;
- (void)createDownloadingTable;
- (void)deleteDownloading:(NSString *)title;

- (void)createDownloadAlreadyTable;
- (void)insertDownloadAlreadyDatabase:(NSString *)title withPicture:(NSString *)picture withAddress:(NSString *)address;
- (void)selectdownloadAlready;
- (void)deleteDownloadAlready:(NSString *)address;
@end
